package com.zzyl.mapper;

import com.zzyl.entity.NursingLevel;
import com.zzyl.vo.NursingLevelAllVo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 11010
* @description 针对表【nursing_level(护理等级表)】的数据库操作Mapper
* @createDate 2024-07-23 16:58:58
* @Entity com.zzyl.entity.NursingLevel
*/
@Mapper
public interface NursingLevelMapper {

    @Select("select * from nursing_level")
    List<NursingLevel> getAll();

    void add(NursingLevel nursingLevel);

    @Select("select * from nursing_level where name = #{name}")
    NursingLevel getByName(String name);

    List<NursingLevel> search(String name, Integer status);

    @Select("select * from nursing_level where id = #{id}")
    NursingLevel getById(Integer id);

    @Delete("delete from nursing_level where id = #{id}")
    void delete(Integer id);

    void update(NursingLevel nursingLevel);
}




